package com.bocom.entity;

import java.util.Date;

import javax.persistence.*;
 
@Entity(name="ajfx")
public class AjfxEntity {
 
//	create or replace view CASEINFOPLT.ajfx as select to_date(to_char(t.collectdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') as jobsubmit,d.areanamecreater as jobowner,to_date(to_char(t.collectdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') as jobsubmitdate,d.caseid as caseid,to_char(d.casedate,'yyyy-mm-dd') as casedate,
//	to_char(d.distributedate,'hh24:mi:ss')  as casetime,d.casetype as casetype,d.caseposition,d.casemethod,d.hassuspectveicle,
//	d.suspectveicletype,d.suspectveiclecolor,d.suspectveiclecard,d.caseaddress,d.caseremark 
//	from CASEINFOPLT.DUTY_AREA t ,CASEINFOPLT.DUTY d where  t.dutyid=d.id and  t.dutystate in (3)  
//	order by d.areanamecreater;
	
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)      
    @Column(name="caseid",length=64)
    private String caseid;  
    
    @Column(name="jobsubmit")
    private Date jobsubmit;   
    
    @Column(name="jobowner",length=100)
    private String jobowner;    
    
    @Column(name="jobsubmitdate")
    private String jobsubmitdate;       
    
    @Column(name="casedate")
    private String casedate;   

    @Column(name="casetime")
    private String casetime;   
    
    @Column(name="rn",length=10)
    private Integer rn;    
    
    @Column(name="casetype",length=10)
    private String casetype;    
    
    @Column(name="caseposition",length=50)
    private String caseposition;  
   
    @Column(name="casemethod",length=10)
    private String casemethod;  
     
    @Column(name="hassuspectveicle",length=10)
    private String hassuspectveicle;
    
    @Column(name="suspectveicletype",length=10)
    private String suspectveicletype;
    
    @Column(name="suspectveiclecolor",length=10)
    private String suspectveiclecolor;
    
    @Column(name="suspectveiclecard",length=50)
    private String suspectveiclecard;
    
    @Column(name="caseaddress",length=200)
    private String caseaddress;
     
    @Column(name="caseremark",length=200)
    private String caseremark;

	public String getCaseid() {
		return caseid;
	}

	public void setCaseid(String caseid) {
		this.caseid = caseid;
	}

	public Date getJobsubmit() {
		return jobsubmit;
	}

	public void setJobsubmit(Date jobsubmit) {
		this.jobsubmit = jobsubmit;
	}

	public String getJobowner() {
		return jobowner;
	}

	public void setJobowner(String jobowner) {
		this.jobowner = jobowner;
	}

	public String getJobsubmitdate() {
		return jobsubmitdate;
	}

	public void setJobsubmitdate(String jobsubmitdate) {
		this.jobsubmitdate = jobsubmitdate;
	}

	public String getCasedate() {
		return casedate;
	}

	public void setCasedate(String casedate) {
		this.casedate = casedate;
	}

	public String getCasetime() {
		return casetime;
	}

	public void setCasetime(String casetime) {
		this.casetime = casetime;
	}

	public Integer getRn() {
		return rn;
	}

	public void setRn(Integer rn) {
		this.rn = rn;
	}

	public String getCasetype() {
		return casetype;
	}

	public void setCasetype(String casetype) {
		this.casetype = casetype;
	}

	public String getCaseposition() {
		return caseposition;
	}

	public void setCaseposition(String caseposition) {
		this.caseposition = caseposition;
	}

	public String getCasemethod() {
		return casemethod;
	}

	public void setCasemethod(String casemethod) {
		this.casemethod = casemethod;
	}

	public String getHassuspectveicle() {
		return hassuspectveicle;
	}

	public void setHassuspectveicle(String hassuspectveicle) {
		this.hassuspectveicle = hassuspectveicle;
	}

	public String getSuspectveicletype() {
		return suspectveicletype;
	}

	public void setSuspectveicletype(String suspectveicletype) {
		this.suspectveicletype = suspectveicletype;
	}

	public String getSuspectveiclecolor() {
		return suspectveiclecolor;
	}

	public void setSuspectveiclecolor(String suspectveiclecolor) {
		this.suspectveiclecolor = suspectveiclecolor;
	}

	public String getSuspectveiclecard() {
		return suspectveiclecard;
	}

	public void setSuspectveiclecard(String suspectveiclecard) {
		this.suspectveiclecard = suspectveiclecard;
	}

	public String getCaseaddress() {
		return caseaddress;
	}

	public void setCaseaddress(String caseaddress) {
		this.caseaddress = caseaddress;
	}

	public String getCaseremark() {
		return caseremark;
	}

	public void setCaseremark(String caseremark) {
		this.caseremark = caseremark;
	}




}
